package www.tshu.dao;

import www.tshu.pojo.Book;
import www.tshu.pojo.PI;
import www.tshu.pojo.Typee;
import www.tshu.pojo.UB;
import www.tshu.util.PageUtil;

import java.sql.SQLException;
import java.util.List;


public interface BookDao {
    int getBookListCount(Book book)throws SQLException;

    List<Book> bookList(Book book,PageUtil pageUtil)throws SQLException;


    int editUB(UB ub)throws SQLException;

    int editBook(UB ub)throws SQLException;

    Double getMoneyById(PI pi)throws SQLException;

    int getBnumberById(String bid)throws SQLException;

    int ediPI(PI pi1)throws SQLException;

    List<UB> borrowListById(String unum,PageUtil pageUtil)throws SQLException;

    int ruternBook(UB ub)throws SQLException;

    List<Typee> getTypeList()throws SQLException;

    List<UB> borrowList(PageUtil pageUtil)throws SQLException;

    int getBorrowListCount()throws SQLException;

    int deleteBorrow(String ubid)throws SQLException;

    int getBooksListCount(Book book)throws SQLException;

    List<Book> booksList(Book book, PageUtil pageUtil)throws SQLException;

    int getBorrowListCountById(String unum)throws SQLException;

    int editState(String bid)throws SQLException;

    int deleteBook(String bid)throws SQLException;

    int selectBorrow(String bid)throws SQLException;

    int addBook(Book book)throws SQLException;

    List<Book> selectBook(String bid)throws SQLException;

    int editBookById(Book book)throws SQLException;
}
